/**
 * This file is part of mycollab-services.
 *
 * mycollab-services is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * mycollab-services is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with mycollab-services.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.mycollab.module.crm.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@SuppressWarnings("ucd")
public class ProductExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public ProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNull() {
            addCriterion("productname is null");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNotNull() {
            addCriterion("productname is not null");
            return (Criteria) this;
        }

        public Criteria andProductnameEqualTo(String value) {
            addCriterion("productname =", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotEqualTo(String value) {
            addCriterion("productname <>", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThan(String value) {
            addCriterion("productname >", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThanOrEqualTo(String value) {
            addCriterion("productname >=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThan(String value) {
            addCriterion("productname <", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThanOrEqualTo(String value) {
            addCriterion("productname <=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLike(String value) {
            addCriterion("productname like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotLike(String value) {
            addCriterion("productname not like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameIn(List<String> values) {
            addCriterion("productname in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotIn(List<String> values) {
            addCriterion("productname not in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameBetween(String value1, String value2) {
            addCriterion("productname between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotBetween(String value1, String value2) {
            addCriterion("productname not between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNull() {
            addCriterion("accountid is null");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNotNull() {
            addCriterion("accountid is not null");
            return (Criteria) this;
        }

        public Criteria andAccountidEqualTo(Integer value) {
            addCriterion("accountid =", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotEqualTo(Integer value) {
            addCriterion("accountid <>", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThan(Integer value) {
            addCriterion("accountid >", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThanOrEqualTo(Integer value) {
            addCriterion("accountid >=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThan(Integer value) {
            addCriterion("accountid <", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThanOrEqualTo(Integer value) {
            addCriterion("accountid <=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidIn(List<Integer> values) {
            addCriterion("accountid in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotIn(List<Integer> values) {
            addCriterion("accountid not in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidBetween(Integer value1, Integer value2) {
            addCriterion("accountid between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotBetween(Integer value1, Integer value2) {
            addCriterion("accountid not between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNull() {
            addCriterion("website is null");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNotNull() {
            addCriterion("website is not null");
            return (Criteria) this;
        }

        public Criteria andWebsiteEqualTo(String value) {
            addCriterion("website =", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotEqualTo(String value) {
            addCriterion("website <>", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThan(String value) {
            addCriterion("website >", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThanOrEqualTo(String value) {
            addCriterion("website >=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThan(String value) {
            addCriterion("website <", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThanOrEqualTo(String value) {
            addCriterion("website <=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLike(String value) {
            addCriterion("website like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotLike(String value) {
            addCriterion("website not like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteIn(List<String> values) {
            addCriterion("website in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotIn(List<String> values) {
            addCriterion("website not in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteBetween(String value1, String value2) {
            addCriterion("website between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotBetween(String value1, String value2) {
            addCriterion("website not between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(Integer value) {
            addCriterion("quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(Integer value) {
            addCriterion("quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(Integer value) {
            addCriterion("quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(Integer value) {
            addCriterion("quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<Integer> values) {
            addCriterion("quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<Integer> values) {
            addCriterion("quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(Integer value1, Integer value2) {
            addCriterion("quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIsNull() {
            addCriterion("serialnumber is null");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIsNotNull() {
            addCriterion("serialnumber is not null");
            return (Criteria) this;
        }

        public Criteria andSerialnumberEqualTo(String value) {
            addCriterion("serialnumber =", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotEqualTo(String value) {
            addCriterion("serialnumber <>", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberGreaterThan(String value) {
            addCriterion("serialnumber >", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberGreaterThanOrEqualTo(String value) {
            addCriterion("serialnumber >=", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLessThan(String value) {
            addCriterion("serialnumber <", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLessThanOrEqualTo(String value) {
            addCriterion("serialnumber <=", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberLike(String value) {
            addCriterion("serialnumber like", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotLike(String value) {
            addCriterion("serialnumber not like", value, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberIn(List<String> values) {
            addCriterion("serialnumber in", values, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotIn(List<String> values) {
            addCriterion("serialnumber not in", values, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberBetween(String value1, String value2) {
            addCriterion("serialnumber between", value1, value2, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andSerialnumberNotBetween(String value1, String value2) {
            addCriterion("serialnumber not between", value1, value2, "serialnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberIsNull() {
            addCriterion("assessnumber is null");
            return (Criteria) this;
        }

        public Criteria andAssessnumberIsNotNull() {
            addCriterion("assessnumber is not null");
            return (Criteria) this;
        }

        public Criteria andAssessnumberEqualTo(String value) {
            addCriterion("assessnumber =", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberNotEqualTo(String value) {
            addCriterion("assessnumber <>", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberGreaterThan(String value) {
            addCriterion("assessnumber >", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberGreaterThanOrEqualTo(String value) {
            addCriterion("assessnumber >=", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberLessThan(String value) {
            addCriterion("assessnumber <", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberLessThanOrEqualTo(String value) {
            addCriterion("assessnumber <=", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberLike(String value) {
            addCriterion("assessnumber like", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberNotLike(String value) {
            addCriterion("assessnumber not like", value, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberIn(List<String> values) {
            addCriterion("assessnumber in", values, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberNotIn(List<String> values) {
            addCriterion("assessnumber not in", values, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberBetween(String value1, String value2) {
            addCriterion("assessnumber between", value1, value2, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andAssessnumberNotBetween(String value1, String value2) {
            addCriterion("assessnumber not between", value1, value2, "assessnumber");
            return (Criteria) this;
        }

        public Criteria andContactidIsNull() {
            addCriterion("contactid is null");
            return (Criteria) this;
        }

        public Criteria andContactidIsNotNull() {
            addCriterion("contactid is not null");
            return (Criteria) this;
        }

        public Criteria andContactidEqualTo(Integer value) {
            addCriterion("contactid =", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidNotEqualTo(Integer value) {
            addCriterion("contactid <>", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidGreaterThan(Integer value) {
            addCriterion("contactid >", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidGreaterThanOrEqualTo(Integer value) {
            addCriterion("contactid >=", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidLessThan(Integer value) {
            addCriterion("contactid <", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidLessThanOrEqualTo(Integer value) {
            addCriterion("contactid <=", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidIn(List<Integer> values) {
            addCriterion("contactid in", values, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidNotIn(List<Integer> values) {
            addCriterion("contactid not in", values, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidBetween(Integer value1, Integer value2) {
            addCriterion("contactid between", value1, value2, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidNotBetween(Integer value1, Integer value2) {
            addCriterion("contactid not between", value1, value2, "contactid");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateIsNull() {
            addCriterion("supportstartdate is null");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateIsNotNull() {
            addCriterion("supportstartdate is not null");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateEqualTo(Date value) {
            addCriterion("supportstartdate =", value, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateNotEqualTo(Date value) {
            addCriterion("supportstartdate <>", value, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateGreaterThan(Date value) {
            addCriterion("supportstartdate >", value, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateGreaterThanOrEqualTo(Date value) {
            addCriterion("supportstartdate >=", value, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateLessThan(Date value) {
            addCriterion("supportstartdate <", value, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateLessThanOrEqualTo(Date value) {
            addCriterion("supportstartdate <=", value, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateIn(List<Date> values) {
            addCriterion("supportstartdate in", values, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateNotIn(List<Date> values) {
            addCriterion("supportstartdate not in", values, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateBetween(Date value1, Date value2) {
            addCriterion("supportstartdate between", value1, value2, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportstartdateNotBetween(Date value1, Date value2) {
            addCriterion("supportstartdate not between", value1, value2, "supportstartdate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateIsNull() {
            addCriterion("supportenddate is null");
            return (Criteria) this;
        }

        public Criteria andSupportenddateIsNotNull() {
            addCriterion("supportenddate is not null");
            return (Criteria) this;
        }

        public Criteria andSupportenddateEqualTo(Date value) {
            addCriterion("supportenddate =", value, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateNotEqualTo(Date value) {
            addCriterion("supportenddate <>", value, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateGreaterThan(Date value) {
            addCriterion("supportenddate >", value, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateGreaterThanOrEqualTo(Date value) {
            addCriterion("supportenddate >=", value, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateLessThan(Date value) {
            addCriterion("supportenddate <", value, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateLessThanOrEqualTo(Date value) {
            addCriterion("supportenddate <=", value, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateIn(List<Date> values) {
            addCriterion("supportenddate in", values, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateNotIn(List<Date> values) {
            addCriterion("supportenddate not in", values, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateBetween(Date value1, Date value2) {
            addCriterion("supportenddate between", value1, value2, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSupportenddateNotBetween(Date value1, Date value2) {
            addCriterion("supportenddate not between", value1, value2, "supportenddate");
            return (Criteria) this;
        }

        public Criteria andSalesdateIsNull() {
            addCriterion("salesdate is null");
            return (Criteria) this;
        }

        public Criteria andSalesdateIsNotNull() {
            addCriterion("salesdate is not null");
            return (Criteria) this;
        }

        public Criteria andSalesdateEqualTo(Date value) {
            addCriterion("salesdate =", value, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateNotEqualTo(Date value) {
            addCriterion("salesdate <>", value, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateGreaterThan(Date value) {
            addCriterion("salesdate >", value, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateGreaterThanOrEqualTo(Date value) {
            addCriterion("salesdate >=", value, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateLessThan(Date value) {
            addCriterion("salesdate <", value, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateLessThanOrEqualTo(Date value) {
            addCriterion("salesdate <=", value, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateIn(List<Date> values) {
            addCriterion("salesdate in", values, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateNotIn(List<Date> values) {
            addCriterion("salesdate not in", values, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateBetween(Date value1, Date value2) {
            addCriterion("salesdate between", value1, value2, "salesdate");
            return (Criteria) this;
        }

        public Criteria andSalesdateNotBetween(Date value1, Date value2) {
            addCriterion("salesdate not between", value1, value2, "salesdate");
            return (Criteria) this;
        }

        public Criteria andUnitpriceIsNull() {
            addCriterion("unitprice is null");
            return (Criteria) this;
        }

        public Criteria andUnitpriceIsNotNull() {
            addCriterion("unitprice is not null");
            return (Criteria) this;
        }

        public Criteria andUnitpriceEqualTo(Double value) {
            addCriterion("unitprice =", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceNotEqualTo(Double value) {
            addCriterion("unitprice <>", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceGreaterThan(Double value) {
            addCriterion("unitprice >", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("unitprice >=", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceLessThan(Double value) {
            addCriterion("unitprice <", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceLessThanOrEqualTo(Double value) {
            addCriterion("unitprice <=", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceIn(List<Double> values) {
            addCriterion("unitprice in", values, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceNotIn(List<Double> values) {
            addCriterion("unitprice not in", values, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceBetween(Double value1, Double value2) {
            addCriterion("unitprice between", value1, value2, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceNotBetween(Double value1, Double value2) {
            addCriterion("unitprice not between", value1, value2, "unitprice");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("description is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("description is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("description =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("description <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("description >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("description >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("description <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("description <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("description like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("description not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("description in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("description not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("description between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("description not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andProducturlIsNull() {
            addCriterion("producturl is null");
            return (Criteria) this;
        }

        public Criteria andProducturlIsNotNull() {
            addCriterion("producturl is not null");
            return (Criteria) this;
        }

        public Criteria andProducturlEqualTo(String value) {
            addCriterion("producturl =", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlNotEqualTo(String value) {
            addCriterion("producturl <>", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlGreaterThan(String value) {
            addCriterion("producturl >", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlGreaterThanOrEqualTo(String value) {
            addCriterion("producturl >=", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlLessThan(String value) {
            addCriterion("producturl <", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlLessThanOrEqualTo(String value) {
            addCriterion("producturl <=", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlLike(String value) {
            addCriterion("producturl like", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlNotLike(String value) {
            addCriterion("producturl not like", value, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlIn(List<String> values) {
            addCriterion("producturl in", values, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlNotIn(List<String> values) {
            addCriterion("producturl not in", values, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlBetween(String value1, String value2) {
            addCriterion("producturl between", value1, value2, "producturl");
            return (Criteria) this;
        }

        public Criteria andProducturlNotBetween(String value1, String value2) {
            addCriterion("producturl not between", value1, value2, "producturl");
            return (Criteria) this;
        }

        public Criteria andSupportcontactIsNull() {
            addCriterion("supportcontact is null");
            return (Criteria) this;
        }

        public Criteria andSupportcontactIsNotNull() {
            addCriterion("supportcontact is not null");
            return (Criteria) this;
        }

        public Criteria andSupportcontactEqualTo(String value) {
            addCriterion("supportcontact =", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactNotEqualTo(String value) {
            addCriterion("supportcontact <>", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactGreaterThan(String value) {
            addCriterion("supportcontact >", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactGreaterThanOrEqualTo(String value) {
            addCriterion("supportcontact >=", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactLessThan(String value) {
            addCriterion("supportcontact <", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactLessThanOrEqualTo(String value) {
            addCriterion("supportcontact <=", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactLike(String value) {
            addCriterion("supportcontact like", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactNotLike(String value) {
            addCriterion("supportcontact not like", value, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactIn(List<String> values) {
            addCriterion("supportcontact in", values, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactNotIn(List<String> values) {
            addCriterion("supportcontact not in", values, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactBetween(String value1, String value2) {
            addCriterion("supportcontact between", value1, value2, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupportcontactNotBetween(String value1, String value2) {
            addCriterion("supportcontact not between", value1, value2, "supportcontact");
            return (Criteria) this;
        }

        public Criteria andSupporttermIsNull() {
            addCriterion("supportterm is null");
            return (Criteria) this;
        }

        public Criteria andSupporttermIsNotNull() {
            addCriterion("supportterm is not null");
            return (Criteria) this;
        }

        public Criteria andSupporttermEqualTo(String value) {
            addCriterion("supportterm =", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermNotEqualTo(String value) {
            addCriterion("supportterm <>", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermGreaterThan(String value) {
            addCriterion("supportterm >", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermGreaterThanOrEqualTo(String value) {
            addCriterion("supportterm >=", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermLessThan(String value) {
            addCriterion("supportterm <", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermLessThanOrEqualTo(String value) {
            addCriterion("supportterm <=", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermLike(String value) {
            addCriterion("supportterm like", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermNotLike(String value) {
            addCriterion("supportterm not like", value, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermIn(List<String> values) {
            addCriterion("supportterm in", values, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermNotIn(List<String> values) {
            addCriterion("supportterm not in", values, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermBetween(String value1, String value2) {
            addCriterion("supportterm between", value1, value2, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupporttermNotBetween(String value1, String value2) {
            addCriterion("supportterm not between", value1, value2, "supportterm");
            return (Criteria) this;
        }

        public Criteria andSupportdescIsNull() {
            addCriterion("supportdesc is null");
            return (Criteria) this;
        }

        public Criteria andSupportdescIsNotNull() {
            addCriterion("supportdesc is not null");
            return (Criteria) this;
        }

        public Criteria andSupportdescEqualTo(String value) {
            addCriterion("supportdesc =", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescNotEqualTo(String value) {
            addCriterion("supportdesc <>", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescGreaterThan(String value) {
            addCriterion("supportdesc >", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescGreaterThanOrEqualTo(String value) {
            addCriterion("supportdesc >=", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescLessThan(String value) {
            addCriterion("supportdesc <", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescLessThanOrEqualTo(String value) {
            addCriterion("supportdesc <=", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescLike(String value) {
            addCriterion("supportdesc like", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescNotLike(String value) {
            addCriterion("supportdesc not like", value, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescIn(List<String> values) {
            addCriterion("supportdesc in", values, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescNotIn(List<String> values) {
            addCriterion("supportdesc not in", values, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescBetween(String value1, String value2) {
            addCriterion("supportdesc between", value1, value2, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andSupportdescNotBetween(String value1, String value2) {
            addCriterion("supportdesc not between", value1, value2, "supportdesc");
            return (Criteria) this;
        }

        public Criteria andCostIsNull() {
            addCriterion("cost is null");
            return (Criteria) this;
        }

        public Criteria andCostIsNotNull() {
            addCriterion("cost is not null");
            return (Criteria) this;
        }

        public Criteria andCostEqualTo(Double value) {
            addCriterion("cost =", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotEqualTo(Double value) {
            addCriterion("cost <>", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThan(Double value) {
            addCriterion("cost >", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThanOrEqualTo(Double value) {
            addCriterion("cost >=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThan(Double value) {
            addCriterion("cost <", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThanOrEqualTo(Double value) {
            addCriterion("cost <=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostIn(List<Double> values) {
            addCriterion("cost in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotIn(List<Double> values) {
            addCriterion("cost not in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostBetween(Double value1, Double value2) {
            addCriterion("cost between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotBetween(Double value1, Double value2) {
            addCriterion("cost not between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andListpriceIsNull() {
            addCriterion("listprice is null");
            return (Criteria) this;
        }

        public Criteria andListpriceIsNotNull() {
            addCriterion("listprice is not null");
            return (Criteria) this;
        }

        public Criteria andListpriceEqualTo(Double value) {
            addCriterion("listprice =", value, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceNotEqualTo(Double value) {
            addCriterion("listprice <>", value, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceGreaterThan(Double value) {
            addCriterion("listprice >", value, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("listprice >=", value, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceLessThan(Double value) {
            addCriterion("listprice <", value, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceLessThanOrEqualTo(Double value) {
            addCriterion("listprice <=", value, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceIn(List<Double> values) {
            addCriterion("listprice in", values, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceNotIn(List<Double> values) {
            addCriterion("listprice not in", values, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceBetween(Double value1, Double value2) {
            addCriterion("listprice between", value1, value2, "listprice");
            return (Criteria) this;
        }

        public Criteria andListpriceNotBetween(Double value1, Double value2) {
            addCriterion("listprice not between", value1, value2, "listprice");
            return (Criteria) this;
        }

        public Criteria andGroupidIsNull() {
            addCriterion("groupid is null");
            return (Criteria) this;
        }

        public Criteria andGroupidIsNotNull() {
            addCriterion("groupid is not null");
            return (Criteria) this;
        }

        public Criteria andGroupidEqualTo(Integer value) {
            addCriterion("groupid =", value, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidNotEqualTo(Integer value) {
            addCriterion("groupid <>", value, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidGreaterThan(Integer value) {
            addCriterion("groupid >", value, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidGreaterThanOrEqualTo(Integer value) {
            addCriterion("groupid >=", value, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidLessThan(Integer value) {
            addCriterion("groupid <", value, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidLessThanOrEqualTo(Integer value) {
            addCriterion("groupid <=", value, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidIn(List<Integer> values) {
            addCriterion("groupid in", values, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidNotIn(List<Integer> values) {
            addCriterion("groupid not in", values, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidBetween(Integer value1, Integer value2) {
            addCriterion("groupid between", value1, value2, "groupid");
            return (Criteria) this;
        }

        public Criteria andGroupidNotBetween(Integer value1, Integer value2) {
            addCriterion("groupid not between", value1, value2, "groupid");
            return (Criteria) this;
        }

        public Criteria andTaxIsNull() {
            addCriterion("tax is null");
            return (Criteria) this;
        }

        public Criteria andTaxIsNotNull() {
            addCriterion("tax is not null");
            return (Criteria) this;
        }

        public Criteria andTaxEqualTo(Double value) {
            addCriterion("tax =", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotEqualTo(Double value) {
            addCriterion("tax <>", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThan(Double value) {
            addCriterion("tax >", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThanOrEqualTo(Double value) {
            addCriterion("tax >=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThan(Double value) {
            addCriterion("tax <", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThanOrEqualTo(Double value) {
            addCriterion("tax <=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxIn(List<Double> values) {
            addCriterion("tax in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotIn(List<Double> values) {
            addCriterion("tax not in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxBetween(Double value1, Double value2) {
            addCriterion("tax between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotBetween(Double value1, Double value2) {
            addCriterion("tax not between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxclassIsNull() {
            addCriterion("taxClass is null");
            return (Criteria) this;
        }

        public Criteria andTaxclassIsNotNull() {
            addCriterion("taxClass is not null");
            return (Criteria) this;
        }

        public Criteria andTaxclassEqualTo(String value) {
            addCriterion("taxClass =", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassNotEqualTo(String value) {
            addCriterion("taxClass <>", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassGreaterThan(String value) {
            addCriterion("taxClass >", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassGreaterThanOrEqualTo(String value) {
            addCriterion("taxClass >=", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassLessThan(String value) {
            addCriterion("taxClass <", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassLessThanOrEqualTo(String value) {
            addCriterion("taxClass <=", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassLike(String value) {
            addCriterion("taxClass like", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassNotLike(String value) {
            addCriterion("taxClass not like", value, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassIn(List<String> values) {
            addCriterion("taxClass in", values, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassNotIn(List<String> values) {
            addCriterion("taxClass not in", values, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassBetween(String value1, String value2) {
            addCriterion("taxClass between", value1, value2, "taxclass");
            return (Criteria) this;
        }

        public Criteria andTaxclassNotBetween(String value1, String value2) {
            addCriterion("taxClass not between", value1, value2, "taxclass");
            return (Criteria) this;
        }

        public Criteria andMftnumberIsNull() {
            addCriterion("mftNumber is null");
            return (Criteria) this;
        }

        public Criteria andMftnumberIsNotNull() {
            addCriterion("mftNumber is not null");
            return (Criteria) this;
        }

        public Criteria andMftnumberEqualTo(String value) {
            addCriterion("mftNumber =", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberNotEqualTo(String value) {
            addCriterion("mftNumber <>", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberGreaterThan(String value) {
            addCriterion("mftNumber >", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberGreaterThanOrEqualTo(String value) {
            addCriterion("mftNumber >=", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberLessThan(String value) {
            addCriterion("mftNumber <", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberLessThanOrEqualTo(String value) {
            addCriterion("mftNumber <=", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberLike(String value) {
            addCriterion("mftNumber like", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberNotLike(String value) {
            addCriterion("mftNumber not like", value, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberIn(List<String> values) {
            addCriterion("mftNumber in", values, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberNotIn(List<String> values) {
            addCriterion("mftNumber not in", values, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberBetween(String value1, String value2) {
            addCriterion("mftNumber between", value1, value2, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andMftnumberNotBetween(String value1, String value2) {
            addCriterion("mftNumber not between", value1, value2, "mftnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberIsNull() {
            addCriterion("vendorPartNumber is null");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberIsNotNull() {
            addCriterion("vendorPartNumber is not null");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberEqualTo(String value) {
            addCriterion("vendorPartNumber =", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberNotEqualTo(String value) {
            addCriterion("vendorPartNumber <>", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberGreaterThan(String value) {
            addCriterion("vendorPartNumber >", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberGreaterThanOrEqualTo(String value) {
            addCriterion("vendorPartNumber >=", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberLessThan(String value) {
            addCriterion("vendorPartNumber <", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberLessThanOrEqualTo(String value) {
            addCriterion("vendorPartNumber <=", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberLike(String value) {
            addCriterion("vendorPartNumber like", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberNotLike(String value) {
            addCriterion("vendorPartNumber not like", value, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberIn(List<String> values) {
            addCriterion("vendorPartNumber in", values, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberNotIn(List<String> values) {
            addCriterion("vendorPartNumber not in", values, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberBetween(String value1, String value2) {
            addCriterion("vendorPartNumber between", value1, value2, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andVendorpartnumberNotBetween(String value1, String value2) {
            addCriterion("vendorPartNumber not between", value1, value2, "vendorpartnumber");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNull() {
            addCriterion("createdTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNotNull() {
            addCriterion("createdTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeEqualTo(Date value) {
            addCriterion("createdTime =", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotEqualTo(Date value) {
            addCriterion("createdTime <>", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThan(Date value) {
            addCriterion("createdTime >", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createdTime >=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThan(Date value) {
            addCriterion("createdTime <", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("createdTime <=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIn(List<Date> values) {
            addCriterion("createdTime in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotIn(List<Date> values) {
            addCriterion("createdTime not in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeBetween(Date value1, Date value2) {
            addCriterion("createdTime between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("createdTime not between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNull() {
            addCriterion("createdUser is null");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNotNull() {
            addCriterion("createdUser is not null");
            return (Criteria) this;
        }

        public Criteria andCreateduserEqualTo(String value) {
            addCriterion("createdUser =", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotEqualTo(String value) {
            addCriterion("createdUser <>", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThan(String value) {
            addCriterion("createdUser >", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThanOrEqualTo(String value) {
            addCriterion("createdUser >=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThan(String value) {
            addCriterion("createdUser <", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThanOrEqualTo(String value) {
            addCriterion("createdUser <=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLike(String value) {
            addCriterion("createdUser like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotLike(String value) {
            addCriterion("createdUser not like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserIn(List<String> values) {
            addCriterion("createdUser in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotIn(List<String> values) {
            addCriterion("createdUser not in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserBetween(String value1, String value2) {
            addCriterion("createdUser between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotBetween(String value1, String value2) {
            addCriterion("createdUser not between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNull() {
            addCriterion("sAccountId is null");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNotNull() {
            addCriterion("sAccountId is not null");
            return (Criteria) this;
        }

        public Criteria andSaccountidEqualTo(Integer value) {
            addCriterion("sAccountId =", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotEqualTo(Integer value) {
            addCriterion("sAccountId <>", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThan(Integer value) {
            addCriterion("sAccountId >", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThanOrEqualTo(Integer value) {
            addCriterion("sAccountId >=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThan(Integer value) {
            addCriterion("sAccountId <", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThanOrEqualTo(Integer value) {
            addCriterion("sAccountId <=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidIn(List<Integer> values) {
            addCriterion("sAccountId in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotIn(List<Integer> values) {
            addCriterion("sAccountId not in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId not between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNull() {
            addCriterion("lastUpdatedTime is null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNotNull() {
            addCriterion("lastUpdatedTime is not null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeEqualTo(Date value) {
            addCriterion("lastUpdatedTime =", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotEqualTo(Date value) {
            addCriterion("lastUpdatedTime <>", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThan(Date value) {
            addCriterion("lastUpdatedTime >", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime >=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThan(Date value) {
            addCriterion("lastUpdatedTime <", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime <=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIn(List<Date> values) {
            addCriterion("lastUpdatedTime in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotIn(List<Date> values) {
            addCriterion("lastUpdatedTime not in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime not between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_product
     *
     * @mbg.generated do_not_delete_during_merge Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_product
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}